package com.vone.export;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;

import com.vone.dao.GetCompany;
import com.vone.entity.Basicdata;
import com.vone.entity.CsCoreLeaguer;
import com.vone.entity.CsCoreLeaguerEdu;
import com.vone.export.until.ExcelStyle;
import com.vone.export.until.ExcelStyleHight;


//创建核心团队，第三个sheet
public class TeamBaseSheet {
	//创建第二个sheeet
	
	private ExcelStyle excelstyle=null;
	private ExcelStyleHight excelstyleheight=null;
	
	List<CsCoreLeaguer> cscoreleaguer=null;
	
	public void getTeamBaseSheet(Basicdata basicdatas){
		//创建第一个sheet
		Sheet sheet3 = ExportUntil.workbook.createSheet("核心团队");
		excelstyle=new ExcelStyle();//实例化样式
		excelstyleheight=new ExcelStyleHight();
		
		// 创建第一个sheet
		HSSFWorkbook wb = (HSSFWorkbook) ExportUntil.workbook;
		sheet3.setColumnWidth(0, 35 * 256);
		sheet3.setColumnWidth(1, 20 * 256);
		sheet3.setColumnWidth(2, 20 * 256);
		sheet3.setColumnWidth(3, 20 * 256);
		sheet3.setColumnWidth(4, 20 * 256);
		sheet3.setColumnWidth(5, 20 * 256);
		sheet3.setColumnWidth(6, 20 * 256);
		
		cscoreleaguer=new ArrayList<CsCoreLeaguer>();
		cscoreleaguer=basicdatas.getCscoreLeaguer();

		HSSFRow row = (HSSFRow) sheet3.createRow(0);
		HSSFCell row_cell = row.createCell(0);
		row_cell.setCellValue("核心团队");
		row.setHeight((short) 800);	
		sheet3.addMergedRegion(new CellRangeAddress(0,0,0,6));
		//row_cell.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
		
		//构建标题样式
		HSSFCellStyle tableCellStyle = wb.createCellStyle();
		tableCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); //左右居中
		tableCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//上下居中
		HSSFFont tableFont = wb.createFont();//构建字体
		tableFont.setFontName("宋体");//设置字体
		tableFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//设置粗体
		tableFont.setFontHeightInPoints((short) 12);//设置字体大小
		tableCellStyle.setFont(tableFont);//应用到样式
		row_cell.setCellStyle(tableCellStyle);//应用到单元格
		
		int onrownum=sheet3.getLastRowNum()+1;
		HSSFRow row0 = (HSSFRow) sheet3.createRow(1);
		HSSFCell row0_cell_0 = row0.createCell(0);
		row0_cell_0.setCellValue("核心团队成员(最少三人)");
		row0.setHeight((short) 800);
		
		if(cscoreleaguer!=null && cscoreleaguer.size()>0){
			//在sheet里创建第0行
			for(int i=0;i<cscoreleaguer.size();i++){	
				HSSFCell row0_cell_1 = row0.createCell(1);
				HSSFCell row0_cell_2 = row0.createCell(2);
				HSSFCell row0_cell_3 = row0.createCell(3);
				HSSFCell row0_cell_4 = row0.createCell(4);
				HSSFCell row0_cell_5 = row0.createCell(5);
				HSSFCell row0_cell_6 = row0.createCell(6);
				
				row0_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row0_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row0_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row0_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row0_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row0_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				
				
				row0_cell_1.setCellValue("姓名");//需要插入的数据
				row0_cell_2.setCellValue("性别");
				row0_cell_3.setCellValue("年龄");//需要插入的数据
				row0_cell_4.setCellValue("职位");
				row0_cell_5.setCellValue("职称");
				row0_cell_6.setCellValue("最高学历");
					
				int conytrownum2=sheet3.getLastRowNum()+1;
				HSSFRow row1 = (HSSFRow) sheet3.createRow(conytrownum2);
				HSSFCell row1_cell_1 = row1.createCell(1);
				HSSFCell row1_cell_2 = row1.createCell(2);
				HSSFCell row1_cell_3 = row1.createCell(3);
				HSSFCell row1_cell_4 = row1.createCell(4);
				HSSFCell row1_cell_5 = row1.createCell(5);
				HSSFCell row1_cell_6 = row1.createCell(6);
				
				
				row1.setHeight((short) 800);
				row0_cell_0.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row1_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row1_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row1_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row1_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row1_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row1_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				
				row1_cell_1.setCellValue(""+cscoreleaguer.get(i).getLeaguer_name()+"");//姓名
				if(cscoreleaguer.get(i).getSex().equals("1")){row1_cell_2.setCellValue("男");}else{row1_cell_2.setCellValue("女");};
				row1_cell_3.setCellValue(""+cscoreleaguer.get(i).getAge()+"");//年龄
				row1_cell_4.setCellValue(""+cscoreleaguer.get(i).getPost()+"");//职位
				row1_cell_5.setCellValue(""+cscoreleaguer.get(i).getTitle()+"");//职称
				row1_cell_6.setCellValue(""+cscoreleaguer.get(i).getOption_name()+"");//最高学历
				
				int conytrownum3=sheet3.getLastRowNum()+1;
				HSSFRow row2 = (HSSFRow) sheet3.createRow(conytrownum3);
				HSSFCell row2_cell_1 = row2.createCell(1);
				HSSFCell row2_cell_2 = row2.createCell(2);
				HSSFCell row2_cell_3 = row2.createCell(3);
				HSSFCell row2_cell_4 = row2.createCell(4);
				HSSFCell row2_cell_5 = row2.createCell(5);
				HSSFCell row2_cell_6 = row2.createCell(6);
				
				row2.setHeight((short) 800);
				row2_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row2_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row2_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row2_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row2_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row2_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				
				row2_cell_1.setCellValue("留学经历");//需要插入的数据
				row2_cell_2.setCellValue("入选国家千人计划");
				row2_cell_3.setCellValue("入选时间");//需要插入的数据
				row2_cell_4.setCellValue("大学生科技企业");
				row2_cell_5.setCellValue("创业次数");
				row2_cell_6.setCellValue("院士");
				
				int conytrownum4=sheet3.getLastRowNum()+1;
				HSSFRow row3 = (HSSFRow) sheet3.createRow(conytrownum4);
				HSSFCell row3_cell_1 = row3.createCell(1);
				HSSFCell row3_cell_2 = row3.createCell(2);
				HSSFCell row3_cell_3 = row3.createCell(3);
				HSSFCell row3_cell_4 = row3.createCell(4);
				HSSFCell row3_cell_5 = row3.createCell(5);
				HSSFCell row3_cell_6 = row3.createCell(6);
				
				row3.setHeight((short) 800);
				row3_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row3_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row3_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row3_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row3_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row3_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				
				if(cscoreleaguer.get(i).getIs_study_abroad().equals("0")){row3_cell_1.setCellValue("否");}else{row3_cell_1.setCellValue("是");}
				if(cscoreleaguer.get(i).getIs_thousand_program().equals("0")){row3_cell_2.setCellValue("否");}else{row3_cell_2.setCellValue("是");}
				if(cscoreleaguer.get(i).getThousand_program_time()!=null){row3_cell_3.setCellValue(""+cscoreleaguer.get(i).getThousand_program_time()+"");}else{row3_cell_3.setCellValue("无");}//入选时间
				if(cscoreleaguer.get(i).getIs_student_entrepreneurship().equals("0")){row3_cell_4.setCellValue("否");}else{row3_cell_4.setCellValue("是");}
				//大学生科技企业
				row3_cell_5.setCellValue(""+cscoreleaguer.get(i).getEntrepreneurship_times()+"");//创业次数
				row3_cell_6.setCellValue(""+cscoreleaguer.get(i).getIs_academician()+"");//院士
				
				int conytrownum5=sheet3.getLastRowNum()+1;
				HSSFRow row4 = (HSSFRow) sheet3.createRow(conytrownum5);
				HSSFCell row4_cell_1 = row4.createCell(1);
				//在sheet里创建第4行
				//设置单元格内容
				row4_cell_1.setCellValue("备注：大学生科技企业：大学生科技企业是指由大学生独自创办或大学生团队合作创办的科技小企业，具备独立企业法人资格；大学生本人应是本企业的专职人员，负责本企业主要的技术研发或经营管理，承担主要职责。其中，大学生，是指高等院校在读或毕业未超过两年的大学生，研究生");//
				//应用样式
				row4.setHeight((short) 2000);
				row4_cell_1.setCellStyle(excelstyleheight.getCellStyleheader());//应用到单元格
				//合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
				sheet3.addMergedRegion(new CellRangeAddress(conytrownum5,conytrownum5,1,6));
				int conytrownum6=sheet3.getLastRowNum()+1;
				HSSFRow row5 = (HSSFRow) sheet3.createRow(conytrownum6);
				HSSFCell row5_cell_1 = row5.createCell(1);
				
				row5.setHeight((short) 800);
				row5_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				
				row5_cell_1.setCellValue("教育经历");
				
				sheet3.addMergedRegion(new CellRangeAddress(conytrownum6,conytrownum6,1,6));
				//sheet3.addMergedRegion(new CellRangeAddress(0,0,1,6));
				int conytrownum7=sheet3.getLastRowNum()+1;
				HSSFRow row6 = (HSSFRow) sheet3.createRow(conytrownum7);
				HSSFCell row6_cell_1 = row6.createCell(1);
				HSSFCell row6_cell_2 = row6.createCell(2);
				HSSFCell row6_cell_3 = row6.createCell(4);
				HSSFCell row6_cell_4 = row6.createCell(5);
				
				row6.setHeight((short) 800);
				row6_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row6_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row6_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row6_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				
				row6_cell_1.setCellValue("学历");
				row6_cell_2.setCellValue("毕业学院");
				row6_cell_3.setCellValue("专业");
				row6_cell_4.setCellValue("毕业时间");
				
				sheet3.addMergedRegion(new CellRangeAddress(conytrownum7,conytrownum7,2,3));//学历标题
				sheet3.addMergedRegion(new CellRangeAddress(conytrownum7,conytrownum7,5,6));//学历标题
				
				
				//团队人员id
				//int tuanduiID = 256;
				//学历集合
				List<CsCoreLeaguerEdu> xueliList = GetCompany.getXueliList(Integer.parseInt(cscoreleaguer.get(i).getId()));
				if(xueliList!=null&&xueliList.size()>0){
					//datasize=xueliList.size();
					int conytrownum8=sheet3.getLastRowNum()+1;
					for(int j=0;j<xueliList.size();j++){
						
						HSSFRow row7 = (HSSFRow) sheet3.createRow(conytrownum8+j);
						HSSFCell row7_cell_1 = row7.createCell(1);
						HSSFCell row7_cell_2 = row7.createCell(2);
						HSSFCell row7_cell_3 = row7.createCell(4);
						HSSFCell row7_cell_4= row7.createCell(5);
						row7.setHeight((short) 800);
						row7_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
						row7_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
						row7_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
						row7_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
						
						
						sheet3.addMergedRegion(new CellRangeAddress(conytrownum8+j,conytrownum8+j,2,3));//学历
						sheet3.addMergedRegion(new CellRangeAddress(conytrownum8+j,conytrownum8+j,5,6));//学历
						
						
						if (xueliList.get(j).getDegree_id().equals("116")) {
							row7_cell_1.setCellValue("本科");
				          }
				          if (xueliList.get(j).getDegree_id().equals("111")) {
				        	  row7_cell_1.setCellValue("博士");
				          }
				          if (xueliList.get(j).getDegree_id().equals("32")) {
				        	  row7_cell_1.setCellValue("大专");
				          }
				          if (xueliList.get(j).getDegree_id().equals("28")) {
				        	  row7_cell_1.setCellValue("硕士");
				          }
				          if (xueliList.get(j).getDegree_id().equals("34")) {
				        	  row7_cell_1.setCellValue("其他");
				          }
						row7_cell_2.setCellValue(""+xueliList.get(j).getSchool_name()+"");
						row7_cell_3.setCellValue(""+xueliList.get(j).getMajor()+"");
						row7_cell_4.setCellValue(""+xueliList.get(j).getGraduation_time()+"");
						}
				}else{
					int conytrownum9=sheet3.getLastRowNum()+1;
					HSSFRow row7 = (HSSFRow) sheet3.createRow(conytrownum9);
					HSSFCell row7_cell_1 = row7.createCell(1);
					HSSFCell row7_cell_2 = row7.createCell(3);
					HSSFCell row7_cell_3 = row7.createCell(4);
					HSSFCell row7_cell_4 = row7.createCell(5);
					row7.setHeight((short) 800);
					row7_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
					row7_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
					row7_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
					row7_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
					
					sheet3.addMergedRegion(new CellRangeAddress(conytrownum9,conytrownum9,2,3));//学历
					sheet3.addMergedRegion(new CellRangeAddress(conytrownum9,conytrownum9,5,6));//学历
				}
				
				int conytrownum9=sheet3.getLastRowNum()+1;
				HSSFRow row8 = (HSSFRow) sheet3.createRow(conytrownum9);
				HSSFCell row8_cell_1 = row8.createCell(1);
				
				row8.setHeight((short) 800);
				row8_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
				row8_cell_1.setCellValue("主要工作经历/主要成就");
				sheet3.addMergedRegion(new CellRangeAddress(conytrownum9,conytrownum9,1,6));
				
				int conytrownum10=sheet3.getLastRowNum()+1;
				HSSFRow row9 = (HSSFRow) sheet3.createRow(conytrownum10);
				HSSFCell row9_cell_1 = row9.createCell(1);
				row9_cell_1.setCellStyle(excelstyleheight.getCellStyleheader());//应用到单元格样式
				
				row9.setHeight((short) 4500);
				row9_cell_1.setCellValue(""+cscoreleaguer.get(i).getWork_experience()+"/"+cscoreleaguer.get(i).getAchievement()+""+"");
				sheet3.addMergedRegion(new CellRangeAddress(conytrownum10,conytrownum10,1,6));
				
			}
		}else{
			HSSFCell row0_cell_1 = row0.createCell(1);
			HSSFCell row0_cell_2 = row0.createCell(2);
			HSSFCell row0_cell_3 = row0.createCell(3);
			HSSFCell row0_cell_4 = row0.createCell(4);
			HSSFCell row0_cell_5 = row0.createCell(5);
			HSSFCell row0_cell_6 = row0.createCell(6);
			
			row0_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row0_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row0_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row0_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row0_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row0_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			
			
			row0_cell_1.setCellValue("姓名");//需要插入的数据
			row0_cell_2.setCellValue("性别");
			row0_cell_3.setCellValue("年龄");//需要插入的数据
			row0_cell_4.setCellValue("职位");
			row0_cell_5.setCellValue("职称");
			row0_cell_6.setCellValue("最高学历");
				
			int conytrownum2=sheet3.getLastRowNum()+1;
			HSSFRow row1 = (HSSFRow) sheet3.createRow(conytrownum2);
			HSSFCell row1_cell_1 = row1.createCell(1);
			HSSFCell row1_cell_2 = row1.createCell(2);
			HSSFCell row1_cell_3 = row1.createCell(3);
			HSSFCell row1_cell_4 = row1.createCell(4);
			HSSFCell row1_cell_5 = row1.createCell(5);
			HSSFCell row1_cell_6 = row1.createCell(6);
			
			
			row1.setHeight((short) 800);
			row0_cell_0.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row1_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row1_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row1_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row1_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row1_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row1_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			
			row1_cell_1.setCellValue("无");//姓名
			row1_cell_2.setCellValue("无");
			row1_cell_3.setCellValue("无");//年龄
			row1_cell_4.setCellValue("无");//职位
			row1_cell_5.setCellValue("无");//职称
			row1_cell_6.setCellValue("无");//最高学历
			
			int conytrownum3=sheet3.getLastRowNum()+1;
			HSSFRow row2 = (HSSFRow) sheet3.createRow(conytrownum3);
			HSSFCell row2_cell_1 = row2.createCell(1);
			HSSFCell row2_cell_2 = row2.createCell(2);
			HSSFCell row2_cell_3 = row2.createCell(3);
			HSSFCell row2_cell_4 = row2.createCell(4);
			HSSFCell row2_cell_5 = row2.createCell(5);
			HSSFCell row2_cell_6 = row2.createCell(6);
			
			row2.setHeight((short) 800);
			row2_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row2_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row2_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row2_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row2_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row2_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			
			row2_cell_1.setCellValue("留学经历");//需要插入的数据
			row2_cell_2.setCellValue("入选国家千人计划");
			row2_cell_3.setCellValue("入选时间");//需要插入的数据
			row2_cell_4.setCellValue("大学生科技企业");
			row2_cell_5.setCellValue("创业次数");
			row2_cell_6.setCellValue("院士");
			
			int conytrownum4=sheet3.getLastRowNum()+1;
			HSSFRow row3 = (HSSFRow) sheet3.createRow(conytrownum4);
			HSSFCell row3_cell_1 = row3.createCell(1);
			HSSFCell row3_cell_2 = row3.createCell(2);
			HSSFCell row3_cell_3 = row3.createCell(3);
			HSSFCell row3_cell_4 = row3.createCell(4);
			HSSFCell row3_cell_5 = row3.createCell(5);
			HSSFCell row3_cell_6 = row3.createCell(6);
			
			row3.setHeight((short) 800);
			row3_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row3_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row3_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row3_cell_4.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row3_cell_5.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row3_cell_6.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			
			row3_cell_1.setCellValue("无");
			row3_cell_2.setCellValue("无");
			row3_cell_3.setCellValue("无");
			row3_cell_4.setCellValue("无");
			//大学生科技企业
			row3_cell_5.setCellValue("无");//创业次数
			row3_cell_6.setCellValue("无");//院士
			
			int conytrownum5=sheet3.getLastRowNum()+1;
			HSSFRow row4 = (HSSFRow) sheet3.createRow(conytrownum5);
			HSSFCell row4_cell_1 = row4.createCell(1);
			//在sheet里创建第4行
			//设置单元格内容
			row4_cell_1.setCellValue("备注：大学生科技企业：大学生科技企业是指由大学生独自创办或大学生团队合作创办的科技小企业，具备独立企业法人资格；大学生本人应是本企业的专职人员，负责本企业主要的技术研发或经营管理，承担主要职责。其中，大学生，是指高等院校在读或毕业未超过两年的大学生，研究生");//
			//应用样式
			row4.setHeight((short) 800);
			row4_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格
			//合并单元格CellRangeAddress构造参数依次表示[起始行,截至行,起始列,截至列]
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum5,conytrownum5,1,6));
			int conytrownum6=sheet3.getLastRowNum()+1;
			HSSFRow row5 = (HSSFRow) sheet3.createRow(conytrownum6);
			HSSFCell row5_cell_1 = row5.createCell(1);
			
			row5.setHeight((short) 800);
			row5_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			
			row5_cell_1.setCellValue("教育经历");
			
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum6,conytrownum6,1,6));
			int conytrownum7=sheet3.getLastRowNum()+1;
			HSSFRow row6 = (HSSFRow) sheet3.createRow(conytrownum7);
			HSSFCell row6_cell_1 = row6.createCell(1);
			HSSFCell row6_cell_2 = row6.createCell(3);
			HSSFCell row6_cell_3 = row6.createCell(5);
			
			row6.setHeight((short) 800);
			row6_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row6_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row6_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			
			row6_cell_1.setCellValue("学历");
			row6_cell_2.setCellValue("毕业学院");
			row6_cell_3.setCellValue("专业");
			
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum7,conytrownum7,1,2));//学历标题
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum7,conytrownum7,3,4));//学历标题
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum7,conytrownum7,5,6));//学历标题
			
			
			int conytrownum8=sheet3.getLastRowNum()+1;	
			HSSFRow row7 = (HSSFRow) sheet3.createRow(conytrownum8);
			HSSFCell row7_cell_1 = row7.createCell(1);
			HSSFCell row7_cell_2 = row7.createCell(3);
			HSSFCell row7_cell_3 = row7.createCell(5);
			row7.setHeight((short) 800);
			row7_cell_1.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row7_cell_2.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			row7_cell_3.setCellStyle(excelstyle.getCellStyleheader());//应用到单元格样式
			
			
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum8,conytrownum8,1,2));//学历
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum8,conytrownum8,3,4));//学历
			sheet3.addMergedRegion(new CellRangeAddress(conytrownum8,conytrownum8,5,6));//学历
			
			row7_cell_1.setCellValue("无");
			row7_cell_2.setCellValue("无");
			row7_cell_3.setCellValue("无");

		}
		sheet3.addMergedRegion(new CellRangeAddress(onrownum,sheet3.getLastRowNum(),0,0));
		
	}

}
